Success Story TopPharm TopPharm offers industry partners a secure KPIaaS platform for accessing sales data, based on Qlik & iVIEW and hosted in the Swiss BI Cloud.
Success Story FRED Financial Data AG FRED Financial Data AG ensures data quality for asset managers and optimizes processes through migration to Qlik Sense.
Success Story TopPharm TopPharm offers industry partners a secure KPIaaS platform for accessing sales data, based on Qlik & iVIEW and hosted in the Swiss BI Cloud.
Success Story FRED Financial Data AG FRED Financial Data AG ensures data quality for asset managers and optimizes processes through migration to Qlik Sense.
Microsoft Power BI Business Analyst Training Practice-oriented training on data analysis and visualisation with Microsoft Power BI. Learn the basics, architecture and practical application in scenarios. Training content Request form Our Expertise MICROSOFT POWER BI BUSINESS ANALYST TRAINING Business analysts have to identify potential and weak points in companies and develop solutions. Our training imparts the right skills for any level of knowledge and any industry in order to use power BI to do so professionally. COURSE DESCRIPTIONThe Power BI Business Analyst training is a scenario-based course that provides basic knowledge of the entire functional scope of Power BI for business users or data analysts. During two days of training, participants will be introduced to the architecture as well as the complete structure of Power BI. In addition, the various methods and best practices that meet the business and technical requirements for modelling, visualising and analysing data with Power BI will be discussed. The course demonstrates how to access and process data from a range of data sources. Different display options for data visualisation will be presented and you will learn how to manage and deploy reports and dashboards for sharing and content distribution. An outlook on the latest and future functionalities of Power BI, practical examples, design concepts and some in-depth topics round off the training. The training material will be provided.Book your training in our E-ShopCONTENTSIntroduction to Power BI.Understanding and using Power BI Service.Connecting and transforming data from different data sources.Defining business rules and KPIs.Analysing data with powerful, interactive visualisation tools.Creating engaging reports.Sharing reports with your team and business partners and publishing them on the web.Writing DAX formulas.Defining calculated tables, columns and metrics.Learning best practices in data preparation and visualisation.Providing reports for mobile application.Getting to know the latest and future functionalities. COURSE REQUIREMENTSKnowledge of ExcelPower BI DesktopData affinity is an advantageKnowledge of working with relational data TECHNICAL REQUIREMENTSMicrosoft Power BI Desktop (free download)PC or laptop with a Windows operating system TARGET GROUPBusiness UsersBusiness AnalystsData AnalystsData Architects LANGUAGEGermanEnglish on request TRAINING MODALITIESClassroom / Virtual / On-sitePublic / Private (for groups of up to 10 persons) DURATION2 days DETAILED PROGRAM FOR MICROSOFT POWER BI BUSINESS ANALYST TRAINING FIRST STEPS WITH MICROSOFT DATA ANALYTICSData analysis and MicrosoftFirst steps with Power BIRETRIEVING DATA IN POWER BIPreparing dataCLEANING, TRANSFORMING AND LOADING DATA INTO POWER BIShaping dataLoading dataDESIGNING A DATA MODEL IN POWER BIIntroduction to data modellingWorking with tablesDimensions and hierarchiesCreating model relationshipsConfiguring tables and column propertiesCreating hierarchiesCREATING MODEL CALCULATIONS WITH DAX IN POWER BIIntroduction to Power DAXCreating calculated tablesCreating calculated columnsCreating key figuresCREATING REPORTS IN POWER BIDesigning a reportCreating and configuring a sync slicerCreating a drill-through pageThe use of conditional formattingCreating and using bookmarksDesigning a reportConfiguring visual fields and format propertiesCREATING DASHBOARDS IN POWER BICreating a dashboardIDENTIFYING PATTERNS AND TRENDS IN POWER BIAdvanced analyticsData insights through AI visualsUse the visual to predict values REQUEST FOR MICROSOFT POWER BI TRAINING Please fill out the form and send us your non-binding enquiry about our Microsoft Power BI training courses. Dates and costs on request. You must have JavaScript enabled to use this form. Salutation - Select -Mr.Mrs. First name Last name Company Your Email Phone Training name - Select -Business AnalystData Analyst PL-300T00Customized Training type - Select -Classroom (Public)On-Site (Private) Number participants Message ✔ Privacy Policy I hereby agree to the privacy policy. * Mandatory field to answer your request Power BI Desktop Power BI Desktop is a free Microsoft app that you install on your local computer. It enables you to connect to many different data sources to transform and visualise them in reports and dashboards.Learn more about Power BI Our Microsoft Power BI Expertise CHOOSE THE RIGHT TRAINING PARTNER! LONG-STANDING MICROSOFT PARTNER CERTIFIED POWER BI DATA ANALYSTS MICROSOFT CERTIFIED TRAINER 2023-2024 You are in good hands at the Informatec Data Intelligence Academy. Data is our passion and turning people into data experts is our vocation. In addition to Power BI training, as a Qlik Authorised Training Partner we offer official Qlik training courses.Visit our Qlik Academy The locations The training courses take place at the COOP Tagungszentrum Muttenz (Basel-Land) or at the Ambassador House Zurich, where participants find the perfect setting for their training. COOP convention center Muttenz (Basel Area) 0 1 2 3 4 Ideal location: 15 minutes’ ride from Basel city centre (tram line 14, stop Freidorf), a few kilometers from the highway, parking availableFirst-class infrastructure: spacious premises, innovative working environment with modern conference facilities, all rooms with natural daylight, soundproof doors and air conditioningPleasant atmosphere: idyllic park, restaurant with market-fresh cuisine, professional service teamAddress: COOP Tagungszentrum, Seminarstrasse 12-22, 4132 MuttenzRoute Ambassador House Zürich 0 1 2 3 In the heart of Zurich North: The district offers a modern residential environment, many new restaurants, numerous shopping opportunities and a recreation area with its own lake. The Ambassador House is easily accessible by car and public transport. Underground parking available.Hotspot for seminars: With various meeting rooms, conference rooms and auditoriums. State-of-the-art technology, first-class facilities, catering of choice and extensive services.Hospitality at a high level: In the Ambassador House and Spaces, experience the flair of the coworking area and move around in a modern city island!Adress: Ambassador House, Thurgauerstrasse101, 8152 OpfikonRoute