Cerca de 10 anos de e...GVT, Algar), Gas LP (Supergasbras). Habilidades: • Administração de banco de dados SQL Server (2008R2/2012 ) • Microsoft SQL Server BI (SSIS, SSRS, SSAS, PowerBI, TSQL, DAX) • Pentaho Integration (Ketlle) • Informatica Powercenter • Modelagem de dados ( relacional e multidimensional ) • Metodologia Agil
...to end setup for an On-Premise and Cloud deployment of Power BI • Understanding of the infrastructure requirements of setting up Power BI from scratch • Hands-on dashboard design on Power BI desktop, must have done report creation using virtualization on Power BI. • Data modelling, Calculations, Conversions, Scheduling Data refreshes in Power BI Desktop
I have 10 excel workbooks with indentical excel sheets (same structure). I want a query (in power BI - DAX) to retrieve the information in these sheets in a single data sheet.
...would be to arrange the charts and indicators of the following 1. Global macro indicators ..about 15 to 20 in a correlated manner ( Dow futures, sgx nifty, Brent Oil, gold, Dax, copper, etc 2. Charts of 80 equities and indices we trade in the futures market. Charts would have to have 10 to 12 indicators as defined by us, such as RSI , Volumes, IV,
...datových výstupů - např. Excel, Databáze (Couchbase), Power BI Tvorba dashboardů v Power BI - získávání dat z datového úložiště příprava potřebných vizualizací (vyžaduje znalost DAX expressions) A po získání vhledu do problematiky možnost designování dashboardů? ...
...and i am Looking for a Person to collect data for me. In Germany we have the DAX (which is similar to the Dow Jones or other Indexes) and i would like to collect the Person data from the financial Statement. I am Talking About all 30 companies which are listed in the DAX. All the data should be stored in a Programm like Excel or a different Programm
...el cual deseo contactar con un profesional para que labore con nosotros. El perfil seria egresado de universidad con las siguientes aptitudes: • Conocimiento intermedio de DAX, Lenguaje M • Conocimiento general de lenguaje R (Opcional) • Conocimiento de programación web, con el objetivo de incrustar reportes Power BI en una página web de manera segura
...in Power BI to work with me the data of my company. The fee will be fixed by each request and payed at the end of the week through paypal. Requests like, how to build this dax formula, how to achieve to this report, or how to organize and improve the data to get better and faster results. My GMT is +0:00 and would like to be available at least 4 hours
...Index constituents) and all major indices USA – all DOW Jones, S&P 500 and NASDAQ stocks and indices UK – FTSE 250 stocks and indices France – CAC stocks and indices Germany – DAX stocks and indices Switzerland – SMI stocks and indices Euroland – Eurostoxx 50 stocks and indices FX pairs – AUD/USD, AUD/NZD, EUR/AUD, EUR/GBP, EUR/JPY, EUR/USD, ...
I have a consolidated table that have to be moved into the power p using Dax. Idea is to avoid vlook up things in the file that is full of them so it really slow.
...critical report currently pulls data from Salesforce, excel sheets, and our data warehouse. It then does a large amount of filtering and data manipulation within Power Query and Dax, then represents the data in ~90 different report pages. We now have all of the SFDC data in our data warehouse. I need someone who can move as much of the data manipulation
Hi I am looking for someone who can consult/assist me with specific problems writing code in excel, dax and sql. Working would be on several projects with a Norwegian internet company, as we look to deepen our understanding of customer trends, selling departments and more. Problem example: We have a customer table consisting of: Customer_id
I have a few dax formulas to get me attrition by date selected. However, if we didn't hire anyone in that time period the calculation is off. I have a calculation to count new hires, one for terminations, one for the start of the month headcount (before any new hires or terminations) and the average headcount. The average headcount is (start of the
...foreign keys. 4. Perform analysis of data by building a cube in tabular model in SSAS with measures and dimensions using star schema. Process and browse the cube and include some DAX/MDX Queries just to show how we retrieve data from a cube. 5. Now visualise data in any of the reporting tools either SSRS or Crystal reports with some good information being
...findings with suitable graphs. *Use the following stock market indices for this project: Use the following stock markets 1. Dow Jones (USA) 2. S&P 500 (USA) 3. Nasdaq (USA) 4 DAX (Germany) 5. FTSE (UK) 6. HangSeng (Hong Kong) 6. Kopsi ( Korea) 7. CNX NIFTY (India)...
...performance of the DAX for 01.01.2012 - 31.12.2014. (Determine the DAX values over the days of the corresponding months and use the arithmetic mean as a dependent variable.) Have the results output and interpret them. Represent the model and data points in a common coordinate system As a database you can use e.g. use: Historical courses DAX [fazer login para ver a URL]
I have a excel file and a test Power BI. I need help to create a DAX formula to calculate attrition. The test file has a hire date and a term date. Need to get the start headcount by removing anyone hired during the selected month or quarter or in the future. Remove any terminated employees that were terminated during the month or quarter selected or
I’m currently working on a PBI visualization project, and I’m struggling to get a measure that would give me accurate Year on Year value. I’d need help with that, similarly displaying month-on-month and quarter-on-quarter data values for specific metrics would be helpful I’d like the project to be completed in the next 2 weeks Any q, please let me know Thanks, Charly
...indicators on dax index: 1) Dax index price with Advance - Decline Volume Line technical indicator., both data horizontal parallel for comparison. 2) Dax index price with 52 week average drawdown or percentage of dax stocks with 2% within All time highs, is it possible to bloomberg show this? both data horizontal parallel for comparison. 3)Dax index
I need an excel formula and a separate DAX formula to count a large dataset of patient visits among many other data points. The count needs to be able to count only the patient account numbers that have charged dollar amounts against the account number by service date month of visit . Distinct count will not work. The account number is shown many times
Code a DAX measure for Power BI that can calculate a weighted average of items, aggregate the data, then apply a second weighted average based on subgroups. All data tables already exist.
Hello here you see a graph: [fazer login para ver a URL] this is created by this shortcode: [mychart name="files/Dax30/[fazer login para ver a URL]" instance=1 minheight=500 removeprice= true] and created by this plugin: mychart-v2.8 (MyChart & Performance Plugin Stock) this plugin loads the data from the website of developer: [fazer login para ver a URL]
Use authentication & authorization in Power BI,• Strong in Analysis Services tabular model, DAX • Strong in Power BI desktop and service • Knowledge on ADF V1 & V2 • Knowledge on Power Shell • Good to have ADLS, ADLA.
POWERBI MODEL: a. Understand how to modify data in power Bi using Power Pivot, DAX. b. Manipulate and model data from an Microsoft SQL database into Power Bi c. Tutelage on Server-side scripting languages & frameworks (python)
please create the following marketscanner in ninjascript: All stocks av...those chosen under a certain condition; have reference to a list. this list is for example: AAPL = NASDAQ SIEMENS = DAX KK = S&P500 As soon as the scanner shows the stocks; the corresponding reference title (like NASDAQ, DAX etc) is also shown and can be analysed.
Dear folks, please create the following marketscanner in ninjascript: All s... those chosen under a certain condition; have reference to a list. this list is for example: AAPL = NASDAQ SIEMENS = DAX KK = S&P500 As soon as the scanner shows the stocks; the corresponding reference title (like NASDAQ, DAX etc) is also shown and can be analysed.
I need a measure formula for powerpivot and MS Power BI to calculate the average payment of a specific identifier (Healthcare CPT Code) from multiple rows that is linked to a date of service and account number. Any other payments or other rows associated with that account that are not specifically tied to the "identifier" CPT code should not be included in the calculation. There are two...
Hi, MUST HAVE POWER BI AND DAX EXPERIENCE – FINANCIAL BACKGROUND WOULD BE HIGHLY RECOMMENDED I have started up a new business which involves reporting and analytics for new vehicle franchise dealers. I have one model which is complete that is excel based and works off a trail balance (totals only no transactions). This will be my base for
I need to replicate excel's sumproduct function using the DAX language in Power BI. I have attached a simple excel spreadsheet with two tabs of input data as well as the output tab I need to recreate using Power BI instead of excel. In this example, each portfolio has a % allocation to multiple strategies and each strategy has a % allocation to multiple
...powerBI model that I need you to work on. You will need to create one Matrix that will have: Monthly/Cumulative/MAT. YTD figures, Month vs Month Percentage. You need to be good at DAX. So it is transforming Excel Report to PowerBI report. The data is already imported into PowerBI. You only need to construct the new measures etc.. The challenging part is that