Tableauaddedcomponentsvide: Complete Technical Guide

The Tableau added components video edition is the screen-capture course of the cement plant analyst: the video sessions that walk the viewer through the construction of the dashboards, click by click, formula by formula: the still document of the components guide becomes the moving demonstration: the viewer watches the data connection, the calculated field, the parameter switch and the dashboard assembly in the real Tableau interface: the video edition multiplies the learning speed of the visual components, because the visual tool is learned by watching the hands that use it: the course is the workshop without the travel.

The Complete Cement Technical Package (931 files including the books, the courses, the Excel tools, the video sessions and the presentations: $249.99 one-time: instant download via the PayPal payment) includes the video edition with the session recordings, the exercise workbooks and the checkpoints: this article walks the course: the session structure, the data preparation, the calculated fields, the dashboard composition and the KPI library: the reader closes the page with the map of the video course and the knowledge of what each session delivers.

The video format answers the real difficulty of the analytics training: the dashboard components are visual and the spreadsheet manuals describe them with the words: the learner of the written guide must translate the sentences into the clicks, and the translation costs time and confidence: the video removes the translation: the viewer sees the cursor move, the menu open and the formula panel fill: the repetition of the observation imprints the motor memory that the written text never reaches: the video edition of the package is the companion of the written guide, and the plants that train their analysts with the pair report the working dashboards within the first two weeks.

1. The Video Course Structure: The Session Map of the Training

The course is organized into the sessions of the focused length: the session is the unit of the training, the average of 10 to 15 minutes, long enough to complete one component and short enough to hold the attention:

• The foundation sessions: the Tableau interface, the data connections and the worksheet mechanics: the vocabulary of the tool, demonstrated on the cement data from the first minute;
• The component sessions: the filters, the parameters, the calculated fields, the sets, the hierarchies and the actions: each component gets its dedicated session with the cement example;
• The dashboard sessions: the assembly of the views into the pages: the KPI cards, the scoreboards and the drill-downs: the composition rules demonstrated on the complete examples;
• The domain sessions: the cement-specific dashboards: the energy board, the quality board, the kiln performance and the dispatch analysis: the sessions where the components meet the process;
• The project sessions: the complete project walkthroughs: the raw data to the published dashboard in one continuous build: the capstone sessions of the course;
• The checkpoint quizzes: the exercise questions at the end of each module: the learner answers on the workbook copy, the answers are reviewed in the following session: the learning control of the course;

The session map of the file is the curriculum of the analyst: the newcomer follows the sessions in the order, the experienced analyst jumps to the domain sessions, and the manager evaluates the progress of the team with the checkpoint scores: the course is the modular curriculum, and the map printed in the guide’s first pages is the navigation instrument of the whole training.

2. The Foundation Sessions: The Interface and the Data of the Cement Plant

The first sessions establish the ground: the interface and the data: the viewer sees the Tableau desktop for the first time and the cement data for the first time, together:

• The interface tour: the data pane, the shelves and the cards of the worksheet: the toolbar and the sheet tabs: the workspace of the analyst, mapped in the ten minutes of the opening session;
• The Excel connection: the quality register of the laboratory opened as the data source: the field types recognized and corrected: the date column, the numeric columns and the text columns checked before the analysis;
• The CSV connection: the process historian exports with the semicolon separators and the thousand separators: the connection options that tame the European exports: the practical detail that saves the first hour of the data work;
• The database connection: the SQL connection to the production database: the tables of the LIMS and the ERP previewed and the joins prepared: the architecture of the plant data, introduced in the session;
• The data interpreter and the cleaning: the date formats, the missing values and the duplicate rows: the data cleaning demonstrated with the real export problems: the quality gate of the analysis;
• The first worksheet: the first drag-and-drop: the daily clinker production by month on the rows and the columns: the first bar chart of the course: the moment the data becomes the picture;

The foundation sessions close with the checkpoint: the learner connects the own quality file and produces the first chart: the session review shows the three common errors of the newcomers: the wrong date parsing, the aggregation mismatch and the orphaned rows of the join: the checkpoint catches the errors in the training room instead of the management meeting, which is the purpose of the exercise design of the course.

The interface habits of the session deserve the note because they shape the whole course: the viewer is taught the keyboard-and-click economy of the tool: the double-click that drops the field, the right-click that converts the measure and the drag-and-drop order that decides the axis roles: the habits demonstrated slowly in the first session and repeated naturally in the later ones: the course designers know that the fluent analyst never thinks about the mechanics, and the video format is the only medium that can teach the fluency: the learner watches the hands of the expert and imitates the economy, while the written guide can only describe the positions of the hands: the motor memory of the tool is the hidden curriculum of the video course, and the foundation sessions lay it down in the first week.

3. The Data Preparation Sessions: The Shape of the Analytical Table

The cement plant data arrives in the shapes that the plant recorded, not the shapes that the analysis needs: the preparation sessions teach the reshaping with the video demonstration:

• The pivot of the quality records: the laboratory rows carry the parameter names and the values in the long format: the analyst pivots the rows into the columns: the CaO, the SiO2, the free lime and the SO3 each become the field of their own: the reshape demonstrated in the session;
• The unpivot of the daily reports: the daily shift report carries the hours in the columns: the analyst unpivots the hours into the rows: the hourly time series that the trends require: the reverse reshape of the previous session;
• The joins of the production tables: the kiln production table joined with the quality table on the date and the shift: the inner and the left joins explained with the cement data: the lost records of the wrong join type, shown in the session;
• The unions of the monthly exports: the twelve monthly quality files stacked into the year table: the union of the same-shaped tables, with the source-month field added by the analyst: the year archive assembled in the minutes;
• The blends of the independent sources: the historian exports and the ERP tables blended on the date without the forced join: the blend discipline of the independent data worlds of the plant: the relationship of the convenient geometry;
• The calculated cleaning fields: the IF fields that flag the impossible values, the TRIM fields that clean the text and the DATEPARSE fields that repair the broken dates: the formula-level cleaning of the data quality;

The preparation sessions are the unglamorous foundation of the reporting, and the video format serves them well: the viewer follows the mouse through the pivot dialog and the union flow, the operations that the written pages describe with the paragraphs: the session ends with the complete analytical table of the cement plant: the single table that carries the production, the quality and the energy of the day, ready for the component sessions that follow.

4. The Calculated Field Sessions: The Formulas of the Cement KPIs

The calculated field sessions are the heart of the video course: the viewer watches the formulas typed, tested and fixed: the cement KPI library of the course is built field by field on the screen:

Table 1: The calculated fields demonstrated in the video sessions

Session	Field built	Formula essence	KPI served
4.1	Specific heat	SUM(heat_mj) / SUM(clinker_tons)	MJ/kg clinker
4.2	Specific power	SUM(kwh) / SUM(cement_tons)	kWh/t cement
4.3	Free lime deviation	AVG(free_lime) − [target param]	Burning stability
4.4	Compliance flag	IF [residue] <= [residue max] THEN 1 ELSE 0	% in window
4.5	Availability	SUM(operating_h) / SUM(calendar_h)	% uptime
4.6	Trend z-score	(value − mean) / stddev	Anomaly watch

The video sessions show the full lifecycle of the formula: the typing of the expression, the syntax error raised and interpreted, the correction, the verification against the known value and the naming with the unit: the naming discipline of the course is strict: the field name carries the unit, so the SPECIFIC_HEAT_MJ_KG appears in the data pane and never the ambiguous Heat: the unit in the name prevents the mixing of the megajoules and the kilowatt-hours in the same dashboard, the classic error of the energy reporting: the session closes with the field library of the module assembled and tested, and the learner repeats the exercise on the own data with the workbook copy of the package.

5. The Filter and Parameter Sessions: The Controls of the Analysis

The controls sessions demonstrate the interactivity of the dashboards: the filters that slice and the parameters that switch: the viewer watches the controls built and wired:

• The quick filter of the product: the cement type selector added to the worksheet and shown in the dashboard: the four clicks of the demonstration: the product slicer of the quality view;
• The date range control: the relative month selector with the presets: the current month, the previous month and the year to date: the time window of the management view, configured in the session;
• The context filter: the date context applied before the calculations: the performance demonstration of the large extract: the before-and-after loading time of the same dashboard: the visible evidence of the context filter value;
• The target parameter: the fineness target parameter created and bound to the compliance calculation: the parameter card on the dashboard: the meeting switches the product class and the compliance recomputes live: the scenario switch of the quality board;
• The price parameter: the energy price parameter bound to the cost fields: the sensitivity of the energy bill demonstrated: the management simulation of the electricity price change: the negotiation instrument of the energy report;
• The parameter-driven top-N: the top clients filter parameter with the integer range: the dynamic ranking of the dispatch view: the dropdown control of the analysis depth;

The controls sessions teach the restraint as well as the mechanism: the video shows the dashboard with the excessive controls and then the disciplined version: the same data, the cleaner page: the guide’s rule of the course: the dashboard carries the controls that the meeting uses, and the rest live in the hidden workbooks: the viewer learns the judgement of the control design, the skill that separates the instrument from the toy: the checkpoint of the module asks the learner to remove half of the controls from the sample dashboard and to argue the choice.

6. The Set and Group Sessions: The Exception Logic of the Reporting

The set sessions demonstrate the marking of the exceptions, the logic that the static charts lack: the viewer watches the sets built from the cement data and the actions wired:

• The computed set of the mills: the finish mills with the specific energy above the 110 kWh/t threshold: the set built with the condition and shown as the red marks on the comparison chart: the exception list of the energy review;
• The constant set of the critical equipment: the kilns, the coolers and the main fans marked as the reference population: the maintenance dashboards compare the critical against the rest: the set of the priorities;
• The group of the product families: the cement types grouped into the general-purpose, the rapid and the special families: the clutter of the fourteen types reduced to the three families for the board view: the grouping of the presentation;
• The combined sets: the intersection of the over-energy and the under-quality sets: the mills that fail both criteria: the intersection analysis of the problematic equipment: the set algebra demonstrated with the real lists;
• The set action on the dashboard: the click on the month in the trend updates the set membership and the quality scatter highlights the same period: the cross-view exploration wired in the session: the interactivity of the exception analysis;
• The set-based coloring: the members of the exception set in red, the others in grey: the traffic light of the exception reporting: the visual discipline that the board reads without the legend;

The set sessions close with the exception dashboard of the plant: the energy, the quality and the availability exceptions assembled into the single page: the viewer sees the complete build from the first set to the final traffic-light board: the session is the turning point of the course, the moment the analyst understands that the dashboard is not the picture of the data but the picture of the questions, and the sets are the grammar of the questions.

7. The Hierarchy and Drill-Down Sessions: The Depth of the Analysis

The drill-down sessions teach the navigation of the plant levels: the hierarchy components demonstrated from the company level to the single silo:

• The equipment hierarchy: the company, the plant, the line, the section, the equipment: the hierarchy field created and the drill paths drawn: the viewer clicks the company and drills to the single mill bearing: the navigation of the accountability;
• The time hierarchy: the year, the quarter, the month, the week, the day, the shift: the custom calendar hierarchy of the plant with the four-shift pattern: the shift drill of the production analysis: the detail that the default calendar lacks;
• The product hierarchy: the family, the type, the class and the silo lot: the dispatch drill from the family to the single delivery: the traceability of the quality reporting: the drill of the complaints investigation;
• The geographic hierarchy: the country, the region and the city of the sales data: the market drill of the demand analysis: the territories of the dispatch map, drilled with the click;
• The drill with the preserved filters: the context maintained through the drill levels: the viewer drills from the annual view to the shift view without losing the product selection: the continuity of the exploration: the discipline of the drill design;
• The KPI-to-level assignment: the table of the course assigns the KPIs to the drill levels: the production to the day, the energy to the shift, the safety to the hour: the level discipline of the reporting architecture;

The hierarchy sessions demonstrate the reporting philosophy of the course: the same workbook serves the whole organization: the board reads the annual picture, the plant manager drills to the month, the shift leader drills to the hour: the single build, the three audiences: the session closes with the complete drill-enabled workbook and the checkpoint asks the learner to define the hierarchy of the own plant and to assign the KPIs to the levels.

8. The Dashboard Composition Sessions: The Assembly of the Page

The composition sessions are the design studio of the course: the viewer watches the separate worksheets assembled into the dashboard page and the layout discipline applied:

Table 2: The dashboard pages built in the composition sessions

Dashboard	Sheets assembled	Controls	Audience
The production scoreboard	KPI cards, daily trend, shift table	Month filter, product parameter	Plant management
The energy board	Specific heat trend, mill comparison, cost cards	Price parameter, line filter	Energy manager
The quality board	Compliance cards, residue trends, distribution	Product parameter, date range	Quality chief
The dispatch board	Sales trend, client ranking, regional map	Top-N parameter, region filter	Sales director
The maintenance board	Work order backlogs, downtime Pareto, critical sets	Equipment set, month filter	Maintenance manager

The composition sessions demonstrate the container layout: the vertical and the horizontal containers, the floating elements avoided, the sizing of the tiles: the viewer watches the dashboard take shape on the screen: the KPI cards at the top, the main trend in the center, the detail table at the bottom: the anatomy of the management page demonstrated on the real examples: the sessions also show the misfits: the dashboard that breaks on the small screen, the chart that hides its axis, the card that floats over the trend: the design errors shown and corrected, because the video teaches the judgment by showing the mistakes as well as the successes.

The composition sessions also teach the device discipline of the dashboard: the cement plant management reads the dashboards on the office screens and on the tablets of the control-room visits: the viewer watches the responsive layout of the containers tested at the different sizes: the fixed-height KPI row that survives the tablet screen and the wide trend that loses its legs on the small screen: the session demonstrates the sizing options of Tableau, the range-based sizing that keeps the scoreboard readable from the phone to the projector: the course’s rule of the composition module: the dashboard must be read in the meeting on the wall projector before it is considered finished: the video shows the board projected on the wall and the management squinting at the legend, the honest reminder that the layout serves the human eye at the distance of the meeting room, not the pixel-perfect preview of the designer’s monitor.

9. The KPI Card Sessions: The Scoreboard Anatomy in Detail

The KPI card sessions zoom into the flagship component: the single number with its trend, its target and its color: the anatomy of the card demonstrated card by card:

• The specific heat card: the big number, the delta against the previous month and the sparkline of the 30 days: the target reference of 3.6 MJ/kg drawn on the sparkline: the card built in the session with the real kiln data;
• The compliance card: the percentage of the tests inside the window, the target of 95% and the red flag of the month below: the IF-based compliance field feeding the card: the quality of the month in the single number;
• The availability card: the kiln availability against the 92% target: the maintenance downtime shown in the tooltip: the card that carries the story of the month in its explanation layer;
• The energy cost card: the electricity bill of the month bound to the price parameter: the management simulation of the tariff: the card that answers the negotiation questions of the board;
• The safety card: the lost-time incidents counter with the zero target: the card that must stay green: the color convention of the safety reporting, fixed in the session: the red flag of the safety card never appears, and the course states the rule without the ambiguity;
• The card layout specification: the exact anatomy of the guide: the number in the top-left, the delta beside, the sparkline below, the unit in the caption: the template of the card saved as the reusable component of the workbook: the copy-paste discipline of the card library;

The card sessions establish the visual language of the plant scoreboard: the same anatomy, the same colors and the same conventions across all the dashboards of the company: the viewer closes the module with the complete card library of the package copied into the own workbook and adapted to the own data: the first page of the scoreboard assembled and published, the visible deliverable of the course at its midpoint.

10. The Storyboard and Reporting Sessions: The Narrative of the Month

The reporting sessions add the narrative layer: the storyboard component that sequences the analysis into the presentation: the video demonstrates the morning report and the monthly review:

• The morning story: the night shift results, the kiln status and the plan of the day: the three-storyboard pages of the morning meeting: the sequence that the plant manager walks through with the team;
• The monthly review story: the production, the energy, the quality, the safety and the dispatch: the five pages of the management review: the story of the month from the numbers to the actions: the narrative arc of the reporting;
• The story mechanics: the captions, the annotations and the page transitions: the presentation mode of the dashboard: the viewer watches the story played in the meeting format: the rehearsal of the review;
• The action tracking page: the decisions of the last meeting with their owners and their due dates: the storyboard page that turns the report into the management instrument: the follow-up loop of the review;
• The exception narrative: the story that walks the exceptions first: the failures, the causes and the corrections: the reporting philosophy of the guide: the exceptions lead, the averages follow;
• The export and the distribution: the PDF export of the story, the scheduled refresh and the sharing: the distribution of the report to the management without the Tableau access: the bridge of the reporting to the whole organization;

The narrative sessions complete the reporting loop: the analysis becomes the story, the story becomes the meeting, the meeting becomes the actions: the course’s message of the module: the dashboard is not the final product, the decision is: the storyboard is the instrument that carries the analysis to the decision, and the video demonstrates the full journey with the cement examples of the monthly management review.

11. The Domain Sessions: The Energy, the Quality and the Kiln Dashboards

The domain sessions apply the components to the cement process: the specialized dashboards of the plant sections: the sessions where the analytics meet the engineering:

• The energy domain: the specific heat of the kiln lines, the specific power of the mills and the cost of the fuels: the energy board of the plant with the parameterized prices: the session demonstrates the complete energy analysis with the balances of the plant: the heat input of the fuel at the typical 3.2 to 3.6 MJ/kg clinker and the electrical 90 to 110 kWh/t cement watched on the trends;
• The quality domain: the free lime, the fineness, the SO3 and the strength trends: the compliance boards of the products: the session builds the quality board with the limit parameters of the standards: the EN 197-1 classes and their early-strength requirements watched on the compliance cards: the 42.5 class at the 10 MPa of the 2-day strength and the 52.5 class at the 20 MPa displayed with their targets;
• The kiln domain: the burning zone temperature, the free lime and the NOx in the joined trends: the correlation scatter of the burning: the session demonstrates the scatter with the temperature on the x-axis and the free lime on the y-axis: the cloud of the points tells the operating window: the data-driven process review of the kiln;
• The mill domain: the Blaine, the residue and the power of the finish mills: the mill comparison chart with the sets of the exceptions: the session builds the mill scoreboard that the grinding engineers review each morning;
• The dispatch domain: the sales trends, the client ranking and the regional map: the demand analysis of the market: the session demonstrates the dispatch board with the top-N parameter and the geographic drill: the sales reporting of the plant;
• The cross-domain board: the integrated plant board: the production, the energy, the quality and the dispatch on the single page: the capstone dashboard of the domain module: the complete picture of the plant in the five tiles;

The domain sessions are where the course proves its cement identity: the components are the means and the process is the end: the analyst of the video course finishes the module with the complete domain board of the plant, built from the own data with the process knowledge of the series: the domain sessions are the bridge between the analytics skills and the cement engineering career, and the guide positions them as the final technical module of the course before the project sessions.

The correlation scatter of the kiln session deserves its deeper mention because it demonstrates the analytical method of the whole course: the viewer watches the analyst question the process with the data: the burning zone temperature against the free lime, each hour a point on the cloud: the low-temperature hours cluster at the high free lime, the high-temperature hours scatter with the variable coating states: the regression line and the confidence band drawn in the session, the R-squared of the relationship discussed with the honesty about the outliers: the analyst learns the statistical reading of the process: the correlation is not the causation, and the outliers are the invitations to the investigation: the session closes with the follow-up drill: the analyst clicks the outlier points, the tooltip shows the date and the shift, and the investigation starts from the shift log: the data analysis of the course always returns to the plant floor, the rule that defines the domain sessions and distinguishes the industrial analytics from the academic exercise.

12. The Project Sessions and the Checkpoints: The Capstone of the Course

The project sessions close the course with the complete builds: the continuous sessions that take the viewer from the raw export to the published dashboard without the cuts: the capstone of the video training:

• Project 1: the energy board from the start: the historian exports loaded, the specific energy fields calculated, the cost parameters added and the dashboard assembled: the full project in the continuous session of the hour: the viewer sees the real pace of the work;
• Project 2: the quality board of the product: the laboratory records reshaped, the compliance flags built, the product parameter wired and the quality story compiled: the second complete project of the course, the repetition that builds the confidence;
• Project 3: the management scoreboard: the KPI cards, the drill-downs, the exception sets and the storyboard: the integrated project that the course evaluates against the checklist: the final deliverable of the trainee;
• The checkpoint reviews: the review videos of the common mistakes of the exercises: the aggregated errors of the course participants explained and corrected on the screen: the collective learning of the community channeled into the course;
• The evaluation rubric: the scoring sheet of the final project: the data quality, the component selection, the KPI correctness, the design and the documentation: the five criteria of the certification: the rubric of the course published in the file;
• The certification: the passing projects receive the certificate of the video course: the certified analyst of the plant reporting: the certificate of the course, recognized in the package’s training track: the professional credential of the reporting work;

The project sessions close the learning loop with the production: the course does not end with the knowledge but with the deliverable: the trainee finishes with the three complete dashboards of the own plant, the certified skills and the maintenance plan of the reporting: the video course of the package is the shortest road from the raw data to the working reporting system, and the project sessions are the proof of the road.

13. Frequently Asked Questions

What is the difference between the video edition and the written component guide?

The written guide is the reference, the video edition is the workshop: the guide documents every component with the tables and the rules, the video demonstrates the construction of the dashboards click by click: the two editions cover the same components and the same cement examples: the analyst learns the mechanics from the video and returns to the written guide for the details and the references: the pair, not the either-or: the package includes both.

Do I need the cement engineering background to follow the sessions?

No: the course builds the cement context from the ground: the sessions introduce each process KPI before the dashboard work: the specific heat, the free lime and the compliance are explained with the values and the targets before they appear in the fields: the engineering background shortens the ramp, but the analyst from the finance or the IT side of the plant follows the course with the same exercises: the course is the joint curriculum of the plant’s reporting team.

How long does the complete video course take?

The full session sequence runs about 12 to 15 hours of the video content, and the recommended pace of the course is two to three sessions per week with the exercises in between: the complete course with the three project builds is a six to eight week part-time program: the concentrated path of the analyst with the pressing deadline follows the domain sessions first and the projects last, the modular design of the course allows both roads.

Do the videos require the same Tableau version?

The recordings use the Tableau Desktop of the 2019 to 2023 era and the components demonstrated are the standard ones of every recent edition: the parameter, the set, the hierarchy and the storyboard functions of the course have been stable across the versions: the learner on the older or the newer version finds the interfaces equivalent, and the guide’s version notes map the minor differences: the component knowledge of the course outlives the versions.

Can the videos be used for the team training?

Yes: the course is designed for the group learning: the sessions are shown on the common screen and the team exercises follow: the checkpoint reviews serve the group discussion and the project rubric allows the fair evaluation of the participants: the plants that train their reporting teams with the video course and the internal mentor report the fastest adoption of the dashboard culture: the video course is the curriculum of the internal academy of the reporting.

Which dashboards of the course are ready to use in the package?

The package ships the complete workbook templates of the course: the production scoreboard, the energy board, the quality board, the dispatch board and the maintenance board: the five dashboards of the composition sessions are included with the sample data: the analyst opens the workbook, replaces the sample data with the own exports and adapts the field names: the first working dashboards of the plant arrive in the days, not the months: the video shows the adaptation path of each template.

14. Conclusion

The Tableau added components video edition: the workshop of the plant analyst: the sessions of the data preparation, the calculated fields, the controls, the sets, the hierarchies, the composition, the KPI cards, the stories and the domain dashboards: the video demonstrates what the written guide documents, and the project sessions certify what the learner builds: the energy board, the quality board and the scoreboard of the own plant: the reporting system of the cement plant, built in the sessions and maintained with the discipline.

The Complete Cement Technical Package includes the video edition with the session recordings, the workbook templates and the checkpoint quizzes: the 931 files, the one-time $249.99, the instant download: the training workshop of the package: the analyst formation, demonstrated and certified: the dashboards of the plant, built on the screen: the reporting culture of the company, launched with the sessions.

This file is part of the Complete Cement Technical Package (931 files) available from cementequipment.org. Respective rights holders; library copy for the licensed single user.