GET TO SPEED with POWER BI, POWER PIVOT and POWER QUERY
Do you spend time each day, week or month cleaning and transforming data into the right format before you can even begin to analyse it or incorporate it into your reports?
Do you perform repetitive data cleansing tasks like:
- Deleting rows, columns, or blanks
- Filtering out data you don’t need
- Fixing the layout so it will work in a Pivot Table
- Splitting or joining columns or text
- Removing spaces and special characters from your data
- Merging worksheets, text/CSV files together
- Extracting data from an external database
- Incorporating the next month’s data to an existing report
- . . . and all the other laborious repetitive tasks that put you to sleep
Do you want to automate the tasks of:
- Transform Messy Data within minutes
- Extracting, Transforming, analyzing and Load 100 million rows in Excel
- Getting your data from almost anywhere – you’re not dependent on IT to give the data to you
- Cleaning, transforming and reformatting your data so it works in Pivot Table, Power Pivot, etc.
- Updating your reports with a click of a “Refresh” button – perform the same tasks so as that you can get your work done faster
- Master M – Language easily with friendly GUI
- . . . and the best part is there is NO macro and NO VBA required!
POWER QUERY, POWER PIVOT and POWER BI
THE NEXT “MUST HAVE” EXCEL SKILLS
What does Power Query ( in Excel – Get and Transform & in Power BI ) do?
- Power Query gets your data from almost anywhere
- Power Query enables you to clean, transform, merge and append data with a point and click style GUI ( Graphical User Interphase ) that’s easier to learn than formulas or VBA
- Power Query loads the data into Excel and or Power Pivot to build excellent visuals and consume it in your analysis, reports or even export elsewhere
- With a week training and tutorials, you’ll be up and running with Power Query!
- Power Query is for every Excel user.
. . . and
POWER PIVOT
- Producing a pivot from two and more worksheets without having anyone enter a VLOOKUP function
- Handle 100 million rows of data in Excel with ease
- Achieve world-class data compression – Store It Column wise
- Do real and amazing powerful things with ‘MEASURES’ in Power Pivot with the new DAX formula language
We offer
- Hands-on Learning
- Completed Excel Power Query workbook files made available during training and as a reference tool you can go back to later on to refresh your memory
- Files are compatible with Excel 2010, 2013, 2016 and Office 365
- In just 5 – days you will be up and running with Power Query
- Lifetime access to the Trainers and workbook files
- . . . and a ‘Certificate of Completion’ which you can add to your resume/CV arsenal
What is Power Query?
Power Query is a free add-in built by Microsoft for Excel users like you and me. It is available in all versions of Excel 2010, 2013, 2016 and Office 365.
In Excel 2016 it’s built right into the Data tab in the ‘Get and Transform Group’
Power Query will get things done for the Excel users without coding. It offers some really cool data transformations.
Who benefits?
- If you use Excel for more than 2 hours a week
- If you are interested in
building a career in:
- Data Science
- Data Analysis
- Big Data Engineering, etc.
- If you are a:
- Business analyst
- Financial modelling expert
- Business professional
We BRIDGE the Data Science TALENT GAP !!!
We offer:
TRAINING AND CONSULTANCY in:
Business intelligence
Data analytics
Advanced MS Excel training
Power BI, Power Pivot and Power Query training
EXECUTIVE COACHING – is available
