Data Analytics for SFE Using Excel, Excel Macros and Python

What is SFE? Why SFE is Needed? How to use SFE in Pharma company? Sales force E ffectiveness  (SFE) describes strategies and technologies that improve the efficiency and effectiveness of the sales team , directly affecting the organisation’s sales achievements and profitability . Finding and exercising the best strategies for SFE requires a thorough analysis of sales force records and other sales data, and here is where lies the problem(s): •         Poor utilization of gathered data. •         Immense data with little to no organisation/management. •         Poor integration to other system data. •         Data sanity. Here are some solutions that we provide for managing and analysing data o    Data Lake Creation: Systemisation of data Easy retrieval and processing of data. Authorisation of the data, resulting in ...

  How to count rows and columns in pandas dataframe. How to count rows in pandas dataframe. print ( len (df.index)) How to get Columns names in pandas dataframe. df.columns How to count Columns in pandas dataframe. print ( len (df. columns ) Visit our website delve solutions

 Useful Excel macros Color  Active Row in Excel where Editing. If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run As many times as you want. When you create a macro, you are recording your mouse Clicks and keystrokes. After you create a macro, you can edit it to make minor Changes to the way it works. Suppose that you always work on large files and even you are freezing header, still you need some highlighter which guide you where your courser is… One of the great macro which can help you is below given. This will highlight the row where are present in excel. Create a macro. 1.       In View Tab. See macros written in the end 2.       Select that 3.       You will see View macro 4.       Click view macros 5.       enter a name for...

Python with MySQL projects

Python with Excel

Useful Excel macros Convert a text to number with excel macro . If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run As many times as you want. When you create a macro, you are recording your mouse Clicks and keystrokes. After you create a macro, you can edit it to make minor Changes to the way it works. Suppose that you always receive files with Numbers as a text. You want to format those text as numbers. You can find a suitable macro in google search a i have given example in bottom and then run a macro that quickly applies These formatting changes to the cells you select. Create a macro. 1.       In View Tab. See macros written in the end 2.       Select the circled option and click  "View Macros". 5.      E nter a name for the macro in the "Macro name" field: 6.   ...