Data Analytics: Data Master, Part 1

Data is the raw material of our time, and it's vastly underutilized. Through DataMaster, you learn how to derive insights from your data to deliver value in ways you've never thought of before.

There are many who know how to access data, even when buried deep in a data warehouse. What's proving a significant challenge is teasing the value out of that data—and it's a familiar story: big IT investment followed by "What now?"

Part 1 of the DataMaster program is a one-week offering designed to rapidly develop the analysts you need. Through the application of an analytic methodology, DataMasters learn how to use familiar tools such as Microsoft Excel (and its powerful Solver and Analysis ToolPak add-ins) to obtain, scrub, explore, model and interpret your data. The DataMaster program will also add new tools to your toolbox, such as Microsoft Power BI and RapAnalyst. 

With this toolset and training, DataMasters gain the skills required to analyze data, build models and create powerful visualizations that lead to valuable insight and better business decisions. 

After completing the DataMaster program, you will be able to:

• Obtain and process disparate sources of data into a format suitable for your analysis work.
• Understand and apply techniques to clean data for effective modeling.
• Analyze, explore and model your data.
• Recognize where key data might be missing and use creative means to find or generate the data that is needed.
• Uncover valuable insight from data using statistical methods and exploratory analysis.
• Communicate data-based findings in visually compelling ways.

• Draw on data available from varied internal, external and cross-domain sources.
• Address difficult problems that have not been solved with conventional tools and wisdom.
• Take complex information and make it easy to understand and communicate.
• May not have a clearly defined outcome by approaching it with an exploration oriented mindset.

• Obtain [your data]
• Scrub [your data]
• Explore [your data]
• Model [your data]
• INterpret [your results]

• Microsoft Excel
• Microsoft Power BI
• RapAnalyst