Learn BI Reporting from the Best Tutors
Search in
Lesson Posted on 12/11/2018 Learn BI Reporting
iTech Analytic Solutions
"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...
Tableau is considered as one of the leading tools in the BI market. Power BI is considered as an emerging tool in close competition with Tableau because of its backend data manipulation features and connectivity with the list of data sources. Tableau is one of the best data visualization tools in the market and is used by medium and large enterprises. Power BI is closely integrated with Office 365 suite, and hence it is compatible other sources such as SharePoint.
Feature | Tableau | Power BI |
---|---|---|
Data Visualization | Tableau provides strong data visualization and is one of the main data visualization tool in the market. | Power BI provides a strong backend data manipulation feature with access to simple visualizations. |
Size of Dataset | Tableau can connect much larger datasets as compared to Power BI. | Power BI has a limit of 1GB data in free version. |
Data Sources | Tableau covers a vast range of data sources to connect with for data visualization. In Tableau, you select the dataset first and visualizations are used on the fly. | Power BI covers most of the data sources available in Tableau. It is closely integrated with Office 365, hence provides connectivity to SharePoint. Power BI online version also supports direct visualization on Search Engine, though, only Bling is supported at this point. |
Costing | Tableau is expensive as compared to Power BI but still under budget for small and medium enterprise. | Power BI provides a free version with 1GB limit on dataset. Power BI Pro is also a cheaper solution when compared with any other BI tool. |
License and Pricing | Tableau Desktop Profession: USD70/user/month and it can connect to hundreds of data sources. Tableau Desktop Personal: USD35/user/month and it can connect to data sources such as Google Sheets and Excel files. Tableau Server: Minimum 10 users with the cost of USD35/user/month Tableau Online with private cloud: USD 42/user/month | Power BI: Free 1 GB storage 10k rows/hour data streaming Power BI Pro: USD9.99/user/month 10 GB storage 1 million rows/hour |
Implementation | Tableau provides different implementation types as per organizational needs panning from few hours to few weeks. | Power BI uses cloud storage and includes simple implementation process. |
Answered on 12/02/2018 Learn BI Reporting
Shubham Agrawal
Trainer
Lesson Posted on 03/01/2018 Learn BI Reporting
iTech Analytic Solutions
"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...
Learn BI Reporting from the Best Tutors
Lesson Posted on 03/01/2018 Learn BI Reporting
iTech Analytic Solutions
"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...
Lesson Posted on 03/01/2018 Learn BI Reporting
iTech Analytic Solutions
"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...
Lesson Posted on 03/01/2018 Learn BI Reporting
iTech Analytic Solutions
"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...
Learn BI Reporting from the Best Tutors
Lesson Posted on 03/01/2018 Learn BI Reporting
iTech Analytic Solutions
"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...
MS Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be aware of most of them. Below is the list of all the major shortcut keys in Microsoft Excel.
Ctrl + A: Selects all contents of the worksheet.
Ctrl + B: Bold highlighted selection.
Ctrl + I: Italicizes the highlighted selection.
Ctrl + K: Inserts link.
Ctrl + U: Underlines the highlighted selection.
Ctrl + 1: Changes the format of selected cells.
Ctrl + 5: Strikethrough the highlighted selection.
Ctrl + P: Brings up the print dialog box to begin printing.
Ctrl + Z: Undo last action.
Ctrl + F3: Opens Excel Name Manager.
Ctrl + F9: Minimizes the current window.
Ctrl + F10: Maximize currently selected window.
Ctrl + F6: Switches between open workbooks or windows.
Ctrl + Page up: Moves between Excel work sheets in the same Excel document.
Ctrl + Page down: Moves between Excel work sheets in the same Excel document.
Ctrl + Tab: Moves between Two or more open Excel files.
Alt + = : Creates a formula to sum all of the above cells
Ctrl + ' : Inserts the value of the above cell into cell currently selected.
Ctrl + Shift + ! : Formats the number in comma format.
Ctrl + Shift + $ : Formats the number in currency format.
Ctrl + Shift + # : Formats the number in date format.
Ctrl + Shift + % : Formats the number in percentage format.
Ctrl + Shift + ^ : Formats the number in scientific format.
Ctrl + Shift + @ : Formats the number in time format.
Ctrl + Arrow key: Moves to the next section of text.
Ctrl + Space: Selects the entire column.
Shift + Space: Selects the entire row.
Ctrl + - : Deletes the selected column or row.
Ctrl + Shift + = : Inserts a new column or row.
Ctrl + Home: Moves to cell A1.
Ctrl + ~ : Switches between showing Excel formulas or their values in cells.
F2: Edits the selected cell.
F3: After a name has been created F3 will paste names.
F4: Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.
F5: Goes to a specific cell. For example, C6.
F7: Spell checks the selected text or document.
F11: Creates chart from the selected data.
Ctrl + Shift + ; : Enters the current time.
Ctrl + ; : Enters the current date.
Alt + Shift + F1: Inserts New Worksheet.
Alt + Enter: While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.
Shift + F3: Opens the Excel formula window.
Shift + F5: Brings up the search box.
Lesson Posted on 03/01/2018 Learn BI Reporting
iTech Analytic Solutions
"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...
Lesson Posted on 03/01/2018 Learn BI Reporting
iTech Analytic Solutions
"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...
i. Built In Functions:
MS Excel has many built in functions, which we can use in our formula. To see all the functions by category, choose Formulas Tab » Insert Function. Then Insert function Dialog appears from which we can choose the function.
ii. Functions by Categories:
Let us see some of the built in functions in MS Excel:
Text Functions:
LOWER: Converts all characters in a supplied text string to lower case.
UPPER: Converts all characters in a supplied text string to upper case.
TRIM: Removes duplicate spaces, and spaces at the start and end of a text string.
CONCATENATE: Joins together two or more text strings.
LEFT: Returns a specified number of characters from the start of a supplied text string.
MID: Returns a specified number of characters from the middle of a supplied text string.
RIGHT: Returns a specified number of characters from the end of a supplied text string.
LEN: Returns the length of a supplied text string.
FIND: Returns the position of a supplied character or text string from within a supplied text string (case-sensitive).
Date & Time:
DATE: Returns a date, from a user-supplied year, month and day.
TIME: Returns a time, from a user-supplied hour, minute and second.
DATEVALUE: Converts a text string showing a date, to an integer that represents the date in Excel's date-time code.
TIMEVALUE: Converts a text string showing a time, to a decimal that represents the time in Excel.
NOW: Returns the current date & time.
TODAY: Returns today's date.
Statistical:
MAX: Returns the largest value from a list of supplied numbers.
MIN: Returns the smallest value from a list of supplied numbers.
AVERAGE: Returns the Average of a list of supplied numbers.
COUNT: Returns the number of numerical values in a supplied set of cells or values.
COUNTIF: Returns the number of cells (of a supplied range), that satisfies a given criteria.
SUM: Returns the sum of a supplied list of numbers.
Logical:
AND: Tests a number of user-defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise.
OR: Tests a number of user-defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwise.
NOT: Returns a logical value that is the opposite of a user supplied logical value or expression i.e. returns FALSE if the supplied argument is TRUE and returns TRUE if the supplied argument is FAL.
Math & Trig:
ABS: Returns the absolute value (i.e. the modulus) of a supplied number.
SIGN: Returns the sign (+1, -1 or 0) of a supplied number.
SQRT: Returns the positive square root of a given number.
MOD: Returns the remainder from a division between two supplied numbers.
Learn BI Reporting from the Best Tutors
Lesson Posted on 15/12/2017 Learn BI Reporting
iTech Analytic Solutions
"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...
UrbanPro.com helps you to connect with the best BI Reporting Training in India. Post Your Requirement today and get connected.
Ask a Question
The best tutors for BI Reporting Classes are on UrbanPro
The best Tutors for BI Reporting Classes are on UrbanPro