Earlier this 12 months, Microsoft introduced it might retire 15 certifications and 44 exams, together with MCSA: BI Reporting, which validated knowledge analysts’ experience utilizing Energy BI and Excel to visualise knowledge through dashboards and studies. The transfer is the fruits of the corporate’s 2018 determination to deal with role-based certifications corresponding to knowledge analyst, knowledge engineer, and knowledge scientist.
Microsoft recommends people who beforehand would have taken the MCSA: BI Reporting certification as a substitute pursue its new Microsoft Licensed: Knowledge Analyst Affiliate certification. The info analyst position studying path nonetheless focuses largely on technical Microsoft Energy BI abilities.
Market intelligence and advisory agency Mordor Intelligence forecasts the worldwide knowledge visualization market to realize a compound annual development charge of greater than 9 % between 2020 and 2025 as companies search to turn into extra analytically pushed. For 13 years working, analysis agency Gartner has rated Microsoft as a frontrunner within the analytics and enterprise intelligence platform house with a “complete and visionary product roadmap and big attain via its Microsoft Workplace channel.” A lot of that rests on the info preparation, visual-based knowledge discovery, interactive dashboards, and augmented analytics of Energy BI.
In response to Glassdoor, knowledge analysts with Energy BI abilities command salaries of $54K to $113K per 12 months ($76,402 common).
What’s a Microsoft Licensed: Knowledge Analyst Affiliate?
Microsoft licensed knowledge analyst associates are subject material specialists that may design and construct scalable knowledge fashions, clear and remodel knowledge, and supply enterprise worth through knowledge visualizations. The certification is meant for knowledge professionals and enterprise intelligence (BI) professionals who use Energy BI to develop studies and dashboards that visualize knowledge, whether or not within the cloud or on-premises. The certification requires passing the Analyzing Knowledge with Microsoft Energy BI certification examination administered through Pearson VUE. The examination measures the candidate’s capacity to arrange knowledge, visualize knowledge, analyze knowledge, and deploy and keep deliverables.
The best way to put together for the Analyzing Knowledge with Microsoft Energy BI examination
Candidates have two choices to arrange for the examination: free on-line programs or instructor-led, paid coaching.
For the free programs, Microsoft recommends a sequence of six studying paths that cowl the mandatory abilities:
Get began with Microsoft knowledge analytics: This studying path supplies an summary of information evaluation and the position of a knowledge analyst, in addition to the talents, duties, and processes they make use of to inform a narrative with knowledge. It consists of two modules and takes 1 hour and 10 minutes to finish.
Put together knowledge for evaluation: This studying path focuses on utilizing Energy Question to extract knowledge from numerous knowledge sources (Microsoft Excel, relational databases, NoSQL knowledge shops) and the way to decide on a storage mode and connectivity sort. It teaches learn how to profile, clear, and cargo knowledge into Energy BI in preparation for modeling knowledge. It consists of two modules that take 3 hours and 26 minutes to finish.
Mannequin knowledge in Energy BI: This studying path teaches learn how to design knowledge fashions and use Knowledge Evaluation Expressions (DAX), the native method and question language of Microsoft Energy BI, to create measures. It consists of three modules that take 5 hours and 31 minutes to finish.
Visualize knowledge in Energy BI: This studying path teaches analysts learn how to choose the proper visuals to unravel a given drawback. It covers report design and formatting, learn how to use report navigation to inform data-driven tales, and the way dashboards may help customers goal report visuals to satisfy particular wants. It consists of 4 modules that take 5 hours and 5 minutes to finish.
Knowledge evaluation in Energy BI: This studying path teaches learn how to use Energy BI to carry out knowledge analytical capabilities. It covers figuring out outliers in knowledge, performing time-series evaluation, utilizing superior analytic options, and dealing with AI visuals. It consists of two modules that take an hour and 52 minutes to finish.
Handle workspaces and datasets in Energy BI: This studying path covers creating workspaces within the Energy BI service. It teaches learn how to deploy Energy BI artifacts and share them with customers, learn how to join Energy BI studies to on-premises knowledge sources, configure automated refresh for Energy BI datasets, and apply row-level safety to limit customers to the info that applies to them. It consists of three modules that take an hour and 10 minutes to finish.
Microsoft additionally supplies a paid, four-day, instructor-led coaching course for the certification through its studying companions. The course covers the strategies and finest practices for modeling, visualizing, and analyzing knowledge with Energy BI. It teaches learn how to entry and course of knowledge from a spread of information sources, together with each relational databases and nonrelational knowledge shops. It additionally covers learn how to implement safety requirements and insurance policies, and learn how to handle and deploy studies and dashboards for sharing and content material distribution. The worth varies by nation and studying companion.
Quite a few apply checks and coaching assets are additionally obtainable for the examination, together with:
Taking the Analyzing Knowledge with Microsoft Energy BI examination
The Analyzing Knowledge with Microsoft Energy BI examination is obtainable through Pearson VUE and prices $165 within the US (the worth varies primarily based on the nation wherein the examination is proctored). For a restricted time, Microsoft is providing discounted certification to qualifying people who’ve been laid off or furloughed as a result of COVID-19 pandemic. To be eligible for the low cost, people should schedule their examination earlier than Dec. 31, 2020, and have till March 31, 2021, to finish the examination.
The examination measures the candidate’s capacity to carry out technical duties, together with:
- Put together knowledge (20%-25%)
- Mannequin knowledge (25%-30%)
- Visualize knowledge (20%-25%)
- Analyze knowledge (10%-15%)
- Deploy and keep deliverables (10%-15%)
Microsoft gives a radical breakdown of the talents measured inside every process.
Copyright © 2020 IDG Communications, Inc.