The second page has the measures displayed with bar chart, matrix table, KPI gauge.
Revenue is measured against country using map, year-manufacturer using line chart and against category-segment-year using play axis (imported from marketplace). The first reporting page is designed to display market share of leading company,% of growth by manufacturer along with a slicer to select date. Visualization templates such as area, donut, pie charts, tables are used in this report. Then the total sales are measured against different variables related to products. The report starts with the date and flag slicers at the top. Apart from different charts, marix tables, slicers, DAX Calculations are used to generate Dynamic Measures and Dynamic Dimensions. The third one is business unit/region report. The second report detailed the avarage values and amounts measured against different variables. The first report draws an visual analysis between salary and employees. Avg Days (visualized as slicer at the top section of the report page). The donut and bar charts are created with DAX Dynamic measure which can be selected against User, Res. The total amount, quantity and avg values are created at the top as cards.
Since the IT tickets need to be measured against multiple variables, I have created slicers for severity, priority, ticket type, satisfaction, departments, requestor seniority and field against cloumns from the dataset. The similar visualization templates are used as previous pages. The fourth page is designed with advanced DAX measures such as Dynamic Measures, Dynamic Dimensions. Visual images are used to clearly differentiate between the cards. A few extra cards are used to show variable amounts and quantities. The third page measure the customer data against the total balance. The first two pages of report contains customer data (ID, job classification, gender, education, marital status, loan default, age group, balance group) represented in slicers, map, bar, column, pie charts. The Total Purchases and Total PO’s are measured against buying package, supplier, stock item, months through donut, bar chart and matrix tables. The report is created with date slicers, multi row card to display total amounts and quantities. Again the matrix tables contain the detailed amounts by product category-sub category level, country-state province level. The first and second page displayed the sales, gross profit amounts by country (map) and year (bar charts). The third page of report has DAX Dynamic measure for both internet and reseller to select the donut charts individually. The internet and reseller sales total and margin details are calculated through DAX measure. The top section of all the report page contains flag (Country), date, category and sub category slicers along with total and gross amounts. DAX Dynamic Measure and Bookmarks technics are also used along with the map, area chart and line-clustered column chart to display total amounts, profit by coutries and month. The second page of report contains Tooltip reporting which is linked with the third page. There are few slicers on the right hand side to see the report by different selection range.
It also contains a multi row card at the top, to display the Total Amounts, Profit % and Average Order. The first page contains sales report by country, segment, discount band and product. Publish, Share and collaborate dashboard, workspace, apps.Building Dashboard to highlight the report using Natural Language Query.Create Dynamic Measure, Dynamic Dimension, Tooltip, Bookmark in reporting.Perform DAX measure calculation using sum, count, calculate, divide, time intelligence.Prepare data Visualization and reporting using Charts(bar, line, column, scatter, pie, donut, ribbon and waterflow ), table, matrix, KPI, slicers, map etc.Create custom tables, relationships, star or snow flakes schema Tables.Transform Data into Data Modeling and explore data by removing duplicates, adding conditionl columns, unpivot-splitting columns, normalize-denormalizing tables.Data Preparation (update and append table).Access Data from cloud, csv, excel, SQL.The skills and technical knowledge applied are as below : All the data, company names used in this portfolio are altered for security and compliance purpose. Power BI Portfolio: Dashboard reporting of Finance, Sales, Procurement, Bank, IT, HR, Product and Manufacture departmentĪs a part of my Power BI porfolio, I will implement Power BI in different sample data sets in relevant Australian industries to demonstrate competency, expertise in power BI reports, dashboards.
0 kommentar(er)
